﻿
  CREATE VIEW [aspnet].[MembershipUsers]
  AS SELECT [aspnet].[Membership].[UserId],
            [aspnet].[Membership].[PasswordFormat],
            [aspnet].[Membership].[MobilePIN],
            [aspnet].[Membership].[Email],
            [aspnet].[Membership].[LoweredEmail],
            [aspnet].[Membership].[PasswordQuestion],
            [aspnet].[Membership].[PasswordAnswer],
            [aspnet].[Membership].[IsApproved],
            [aspnet].[Membership].[IsLockedOut],
            [aspnet].[Membership].[CreateDate],
            [aspnet].[Membership].[LastLoginDate],
            [aspnet].[Membership].[LastPasswordChangedDate],
            [aspnet].[Membership].[LastLockoutDate],
            [aspnet].[Membership].[FailedPasswordAttemptCount],
            [aspnet].[Membership].[FailedPasswordAttemptWindowStart],
            [aspnet].[Membership].[FailedPasswordAnswerAttemptCount],
            [aspnet].[Membership].[FailedPasswordAnswerAttemptWindowStart],
            [aspnet].[Membership].[Comment],
            [aspnet].[Users].[ApplicationId],
            [aspnet].[Users].[UserName],
            [aspnet].[Users].[MobileAlias],
            [aspnet].[Users].[IsAnonymous],
            [aspnet].[Users].[LastActivityDate]
  FROM [aspnet].[Membership] INNER JOIN [aspnet].[Users]
      ON [aspnet].[Membership].[UserId] = [aspnet].[Users].[UserId]
  